package com.system.provider;

import com.am.ui.grid.AbstractBaseGridProvider;
import com.system.uitls.SearchFilter;
import java.util.Map;

public class PersonListProvider extends AbstractBaseGridProvider
{
  public String generateSql(Map<String, Object> map)
  {
    StringBuffer sql = new StringBuffer("SELECT id,name,sex,birthday,num,type,id_card,telephone,anamnesis,social_security,class,address,campus,card_num,status,is_overdue,is_public_medicine,choose_hospital FROM sys_person WHERE type=:type");

    sql.append(SearchFilter.getSearchSql(map, null));
    setParamMap(map);
    return sql.toString();
  }
}